package mysql

const (
	user = `create table if not exists user(
     		id INT NOT NULL AUTO_INCREMENT,
     		username VARCHAR(20) NOT NULL unique,
     		password VARCHAR(20) NOT NULL,
			phone VARCHAR(12),
			age INT(3),
			sex VARCHAR(20),
			addr VARCHAR(100),
     		PRIMARY KEY ( id )
		)ENGINE=InnoDB DEFAULT CHARSET=utf8;`
	history = `create table if not exists history(
     		user_id INT(10) NOT NULL,
			isWin INT(1) NOT NULL,
			chess TEXT,
     		PRIMARY KEY ( user_id )
		)ENGINE=InnoDB DEFAULT CHARSET=utf8;`
)

//func init()  {
//	DB.Execute(user)
//	DB.Execute(history)
//}
